<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">
  <meta name="keywords" content="hexo,个人博客,blog" />
  <meta name="description" content="赚钱，裸辞开店！！" />
  <meta http-equiv="x-dns-prefetch-control" content="on">
  <link rel="dns-prefetch" href="https://busuanzi.ibruce.info">
  <link rel="dns-prefetch" href="https://at.alicdn.com">
  
  <link rel="dns-prefetch" href="https://widget.daovoice.io">
  <link rel="dns-prefetch" href="https://widget-static-cdn.daovoice.io">
  <link rel="dns-prefetch" href="https://im.daovoice.io">
  
  
  <link rel="dns-prefetch" href="https://hm.baidu.com/">
  
  
  <link rel="stylesheet" type="text/css" href="/./style/main.css">
	<link rel="shortcut icon" href="/favicon.ico" title="Favicon">
  <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/gitalk@1/dist/gitalk.css">
	<title>Kyist</title>
  
  <script>var _hmt=_hmt||[];(function(){var hm=document.createElement("script");hm.src="https://hm.baidu.com/hm.js?awwssw1snsnsnn1ndndnndnd99j";var s=document.getElementsByTagName("script")[0];s.parentNode.insertBefore(hm,s);})();
  </script>
  
  
    <script>(function(i,s,o,g,r,a,m){i["DaoVoiceObject"]=r;i[r]=i[r]||function(){(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;a.charset="utf-8";m.parentNode.insertBefore(a,m)})(window,document,"script",('https:' == document.location.protocol ? 'https:' : 'http:') + "//widget.daovoice.io/widget/123456.js","daovoice");daovoice('init',{app_id: "123456"});daovoice('update');
  </script>
  
<meta name="generator" content="Hexo 6.3.0"></head>
<body>
  <div class="left-aside">
    <div class="face-img"><img src="/img/zz.png"></div>
    <div class="intro-word">
        <h2></h2>
        <p></p>
    </div>
    <div class="sns">
        <ul>
            
            <li>
                <a class="github" target="_blank" href="https://github.com/88888888" title="github">
                    <img src="/./img/icon-github.png" alt="github" data-tooltip="github">
                </a>
            </li>
            
            <li>
                <a class="weibo" target="_blank" href="http://weibo.com/u/888888888" title="weibo">
                    <img src="/./img/icon-weibo.png" alt="weibo" data-tooltip="weibo">
                </a>
            </li>
            
            <li>
                <a class="email" target="_blank" href="mailto:1223456@666666.com" title="email">
                    <img src="/./img/icon-email.png" alt="email" data-tooltip="email">
                </a>
            </li>
            
            <li>
                <a class="sf" target="_blank" href="https://segmentfault.com/u/555555" title="sf">
                    <img src="/./img/icon-sf.png" alt="sf" data-tooltip="sf">
                </a>
            </li>
            
            <li>
                <a class="rss" target="_blank" href="/atom.xml" title="rss">
                    <img src="/./img/icon-rss.png" alt="rss" data-tooltip="rss">
                </a>
            </li>
            
        </ul>
    </div>
</div>
<div class="right-aside">
    <div class="right-nav ms">
        <div class="main">
          <svg id="nav-menu" class="icon icon-menu" aria-hidden="true">
            <use xlink:href="#icon-menu"></use>
          </svg>
          <ul class="left">
              
              <li>
                  <a href="/2014/friends/">
                      友链
                  </a>
              </li>
              
          </ul>
          <div class="search">
            <div class="search-box">
              <input type="search"  id="search" class="input-search" placeholder="搜索">
              <i class="icon-search"></i>
              <div class="search-result-box">
                <ul id="search-result"></ul>
              </div>
            </div>
            <svg id="nav-search" class="icon icon-search" aria-hidden="true">
              <use xlink:href="#icon-search"></use>
            </svg>
          </div>
        </div>
    </div>
    <div class="right-main">
        <div class="category">
            <ul>
                <li><a href="/" class="">最新</a></li>
                
                    <li><a href="/categories/SQL/" class="">SQL</a></li>
                
                    <li><a href="/categories/js/" class="">js</a></li>
                
                    <li><a href="/categories/nginx/" class="">nginx</a></li>
                
                    <li><a href="/categories/spi/" class="">spi</a></li>
                
                    <li><a href="/categories/命令/" class="">命令</a></li>
                
                    <li><a href="/categories/排序算法/" class="">排序算法</a></li>
                
                    <li><a href="/categories/计算机/" class="">计算机</a></li>
                
                    <li><a href="/categories/过滤器/" class="">过滤器</a></li>
                
            </ul>
        </div>
        <div class="clear"></div>
        <div class="list">
            <div>
                
                
  
    <div class="item">
      <div class="title">
        <a href="/2023/01/12/oracle%E5%A4%9A%E8%A1%8C%E8%BD%AC%E5%A4%9A%E5%88%97/">oracle 多行转多列</a>
      </div>
      <div class="info">
        <ul>
          <li>发布 <time datetime="2023-01-12T15:58:59.000Z" itemprop="date">2023-01-12</time>
          </li>
          <li>更新 <time datetime="2023-02-12T16:01:37.012Z" itemprop="dateUpdated">2023-02-13</time>
          </li>
          <!--<li> 评论 <span id = "url::https://kyist.gitee.io/2023/01/12/oracle%E5%A4%9A%E8%A1%8C%E8%BD%AC%E5%A4%9A%E5%88%97/" class = "cy_cmt_count" ></span>
          </li>-->
        </ul>
      </div>
    </div>
  


                
                

            </div>
        </div>
        <div class="clear"></div>
        <div class="hosted">
          <ul>
            <li class="coding">
              <a target="_blank" rel="noopener" href="https://coding.net/pages">
                <img src="/./img/coding.png">
              </a>
            </li>
            <li class="github-pages">
              <a target="_blank" rel="noopener" href="https://pages.github.com">
                <img src="/./img/github-pages.png">
              </a>
            </li>
          </ul>
        </div>
    </div>
</div>
<script>
  var homeLeftBgArr = 'https://kyist.gitee.io/img/ha.jpg'.split(',');
  var homeLeftBgArrLen = homeLeftBgArr.length;
  var leftBackgroundUrl = homeLeftBgArr[Math.floor(Math.random() * homeLeftBgArrLen)];
  var homeLeftAsideNode = document.getElementsByClassName('left-aside')[0];
  if (homeLeftAsideNode) {
    homeLeftAsideNode.style.backgroundImage = 'url(' + leftBackgroundUrl + ')';
  }
</script>
<script async src="//busuanzi.ibruce.info/busuanzi/2.3/busuanzi.pure.mini.js"></script>
</script>
<script>//console
  var consoleConfig = ''.split(',');
  var canConsole = ;
  var consoleInfo = (function(consoleConfig) {
  if (!canConsole || !consoleConfig || consoleConfig.length < 1) {
    return;
  }
  var consoleColor = '#6190e8';
  var _console;
  var backgroundTextStyle = 'padding: 1px 5px;color: #fff;background: ' + consoleColor + ';'
  var textStyle = 'color: ' + consoleColor + ';';

  consoleConfig.map(o => {
    var num = (o.match(/%c/g) || []).length;
    if(/^http(s)?:\/\//.test(o)) {
      console.log('%c     ', 'background: url(' + o + ') no-repeat left center;font-size: 180px;');
      return;
    }
    if (num > 0) {
      var logArguments = [];
      for (var i = 0; i < num; i++) {
        if (i % 2 === 0) {
          logArguments.push(backgroundTextStyle);
        } else {
          logArguments.push(textStyle);
        }
      }
      (_console = console).log.apply(_console, ['%c' + o, textStyle].concat(logArguments));
      return;
    }
    console.log('%c' + o, textStyle);
  });
}(consoleConfig));</script><script type="text/javascript" src="/./js/main.js"></script>

  <script src="//at.alicdn.com/t/font_159214_mvtxvg9me9.js"></script>
</body>
</html>
